EPTNUM2TXT
(Only available in the full registered version of Edwin's Power Tools.)
Translates a number into English Language text.
Syntax
EPTNUM2TXT(number, frac, places, dollar_txt, cent_txt, output_case, smart_case)
number is the number to be translated into English. It can be either a positive or a negative number; with/without decimal places. It may also be in scientific format, e.g. 234E+17
frac is a number either 1, 2, or 3. It determines the way decimal places (, if any,) are being treated. Default value is 1. (Optional)
Set frac equals to |
If decimal places exist |
1 or omitted |
Translated into a fraction. e.g. 0.27 = 27/100 ; 0.12345 = 12345/100000 |
2 |
Translated into English words. e.g. 0.27 = zero point two seven |
3 |
Completely ignore any decimal places. e.g. 1.6 = one |
place determines how many decimal places (,if any,) to which you want to round number. (Optional)
dollar_txt is the text string to be placed before the decimal places. (Optional) For example, when translating the number 123,
dollar_txt |
Translation output |
Dollar |
One-Hundred Twenty-Three Dollar |
Pound |
One-Hundred Twenty-Three Pound |
cent_txt is the text string to be placed after the decimal places. (Optional)
For example, when translating the number 123.25,
dollar_txt |
cent_txt |
Translation ouput |
Dollar |
Cent |
One-Hundred Twenty-Three Dollar Twenty-Five Cent |
Pound |
Pence |
One-Hundred Twenty-Three Pound Twenty-Five Pence |
output_case is a number either 1, 2 or 3. It determines whether the output text string is in upper, lower, or proper case. Default value is 1. (Optional)
Set output_case equals to |
Effect |
1 or omitted |
Output text in UPPER case |
2 |
Output text in lower case |
3 |
Output text in Proper case |
smart_case is a Boolean value either TRUE or FALSE. It determines whether the word AND should always be in lower case. Default value is FALSE. (Optional)
Set smart_case equals to |
Effect |
TRUE |
The word and always in lower case |
FALSE or omitted |
The word and follows the value of the variable output_case. |
Limitations
Remarks
EPTNUM2TXT translation employs the following definitions :